Release 10.1A: OpenEdge Development:
ProDataSets

Populating a ProDataSet

To populate the ProDataSet’s tables in a uniform way, there is a FILL method that you can apply to either the ProDataSet as a whole or to a member buffer. Before you do a FILL, you must prepare a query for each top-level table you are filling. If you do not do this, then that table is filled with all records from its Data-Source. Even when you are using a static query for a table, you must use the dynamic QUERY-PREPARE method to define the selection criteria for it. Progress cannot associate a static OPEN QUERY statement with a ProDataSet.

For example, to fill the dsOrder ProDataSet with Order number 1 and all its OrderLines and Items, you prepare this query on the query you have associated with that temp-table:

QUERY qOrder:QUERY-PREPARE("FOR EACH Order WHERE Order.OrderNum = 1, " + "FIRST Customer OF Order, FIRST SalesRep OF Order").

Progress opens the query for you when you start the FILL. If the Data-Relations describe the parent-child relationships for children of the top-level table, then you don’t need to define or prepare an explicit query for them.